791bca26126664531d060b47d7910ff1977ee66e,jooq/jooq-mysql/src/test/java/com/vladmihalcea/book/hpjp/jooq/mysql/crud/UpsertTest.java,UpsertTest,upsert,#DSLContext#,27
Before Change
private void upsert(DSLContext sql) {
sql
.insertInto(POST)
.columns(POST.ID, POST.TITLE)
.values(1L, "High-Performance Java Persistence")
.onDuplicateKeyUpdate()
.set(POST.TITLE, "High-Performance Java Persistence Book")
After Change
private void upsert(DSLContext sql, Long id, String owner, Timestamp timestamp) {
sql
.insertInto(POST_DETAILS)
.columns(POST_DETAILS.ID, POST_DETAILS.CREATED_BY, POST_DETAILS.CREATED_ON)
.values(id, owner, timestamp)
.onDuplicateKeyUpdate()
.set(POST_DETAILS.UPDATED_BY, owner)
.set(POST_DETAILS.UPDATED_ON, timestamp)